package org.jeecg.modules.basic.entry.mapper;

import java.util.List;
import java.util.Map;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.ibatis.annotations.Param;
import org.jeecg.modules.basic.demo.student.entity.LwgyBaseStudent;
import org.jeecg.modules.basic.entry.entity.LwgyFjInout;
import org.jeecg.modules.basic.entry.entity.LwgyInoutRecord;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.jeecg.modules.basic.entry.entity.LwgyStudentInout;


/**
 * @Description: 出入管理
 * @Author: jeecg-boot
 * @Date:   2020-12-04
 * @Version: V1.0
 */
public interface LwgyInoutRecordMapper extends BaseMapper<LwgyInoutRecord> {
    LwgyBaseStudent queryStuByNumString(String studentNumber);

    List<Map<String, String>> roommateInout(String roomId);
    List<Map<String, String>> getStudentFjById(String userId);
    IPage<LwgyFjInout> totalPage(Page<LwgyFjInout> page, @Param(Constants.WRAPPER) QueryWrapper<LwgyFjInout> queryWrapper);
    Integer updateStuInfo(String id, String direction, String updateTime);

    List<LwgyStudentInout> stuPageList(Page<LwgyStudentInout> page, @Param(Constants.WRAPPER)QueryWrapper<LwgyStudentInout> queryWrapper);
    List<LwgyStudentInout> bedPageList();

    List<LwgyStudentInout> outStuPageList();

    //在寝室人数统计（按楼宇）
    List<Map<String, String>> StaOfDormitoryPopulationByBuilding(String id);
    //在寝室人数统计（按学院）
    List<Map<String, String>> StaOfDormitoryPopulationByCollege(String id);


}
